///Project: Introducing GLP Paper Table 7
///Date:14 09 2018 
///Stata14 

**************** Table 7**************************
clear all
use "/Users/erzeno/Dropbox/GLP/JG_EO_Papers/Introducing GLP Paper/Publication/PoP/Submission 2 (Bernhard)/Round 3/Replicationdata/MP Salaries.dta"
gen MPsalary=MPSalaryUSAnnual
keep if MPsalary<.
replace MPsalary=round(MPsalary)
sort MPsalary
sum MPsalary
sum MPsalary if wealth==1
sum MPsalary if wealth==0
sum MPsalary if regime==0
sum MPsalary if regime==1
sum MPsalary if region==1
sum MPsalary if region==2
sum MPsalary if region==3
sum MPsalary if region==4
sum MPsalary if region==5
////Row2 
gen salarygdp1=MPsalary/GDPpercapitaCurrentUS
sum salarygdp1
sum salarygdp1 if wealth==1
sum salarygdp1 if wealth==0
sum salarygdp1 if regime==0
sum salarygdp1 if regime==1
by region, sort: sum  salarygdp1


